Create Table
AutomatR.Excel.Activities.CreateTable
The "Create Table" activity in AutomatR is part of the Excel activities package, designed to simplify the process of creating a table from a specified range within an Excel workbook. This activity enhances the efficiency of automation workflows involving data organization and analysis in Excel.
Properties
| Name | Description |
|---|---|
| Input | |
| Range | Enter the range specifying on which the table will be created. String variables containing the range. |
| Table Name | Enter the new table name. String variables containing the table name. |
| Table Style | Enter the table style (e.g., "TableStyleDark5"). String variables containing the table style. If not provided, the default style is "TableStyleMedium15". |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Create Table" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Create Table" activity onto the workflow.
- Configure the properties by specifying the range, table name, and optionally the table style.
- Optionally, configure the delay.
- Execute the workflow to create the specified table within the Excel workbook.
Example: Consider an example where the "Create Table" activity is used to create a new table named "SalesTable" from the range "A1:D100" with the "TableStyleLight9" style and a 2-second delay:
Create Table:
Table Name: "SalesTable"
Range: "A1:D100"
Table Style: "TableStyleLight9"
Delay: 2
In this example, the activity creates a new table named "SalesTable" from the range "A1:D100" with the "TableStyleLight9" style and a 2-second delay, allowing time for any necessary cleanup or synchronization.